﻿<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
	<meta name="viewport" content="width=device-width, initial-scale=0.0, user-scalable=no, minimum-scale=1.0, maximum-scale=1.0" />
	<meta name="keywords" content="新创社" />
	<meta name="description" content="新创社会创新">
	<meta name="author" content="新创社" />
	<meta content="yes" name="apple-mobile-web-app-capable">
	<meta content="black" name="apple-mobile-web-app-status-bar-style">
	<meta content="telephone=no" name="format-detection">
	<title>新创社会创新</title>
    <script type="text/javascript" src="../js/jquery.min.js"></script>
    
   <!-- <script type="text/javascript" src="js/project.js"></script> -->
	<link rel="stylesheet" type="text/css" href="../css/indexstyle.css" />
    <link rel="stylesheet" type="text/css" href="css/projectstyle.css" />
   
	<link rel="apple-touch-icon-precomposed" href="../img/default/defaultshare.jpg">
	<link href="../img/icons/favicon.ico" rel="shortcut icon" type="image/x-icon">
</head>
<body>
		<div class="head">
			<!-- Header -->
			<div id="header">
				<a id="menu" href="#menu"></a>
				<span id="Logo" class="svg">
					<img src="../img/icons/logo.png" />
				</span>
				<a class="backBtn" href="projectre.php" >发布</a>
			</div>
            <!--End Header-->
			<div class="subHeader"><i class="i-home i-small"></i>项目</div>
			
		</div>
        <div class="main"  id="wrapper">  
       	    <form  id="fform" method="post">
             	 <table>
                    <tr>
                        <td>
                            <select id="atype" name="atype">
                                <option value="0">选择类型</option>
                                <option value="1">分享会</option>
                                <option value="2">研讨会</option>
                                <option value="3">路演会</option>
                                <option value="4">众筹会</option>
                                <option value="5">观影会</option>
                                <option value="6">悦读会</option>
                                <option value="7">发布会</option>
                                <option value="8">博览会</option>
                                <option value="9">展销会</option>
                                <option value="10">招聘会</option>
                                <option value="11">交流会</option>
                                <option value="12">培训会</option>
                                <option value="13">充电会</option>
                                <option value="14">其他</option>                    
                            </select>
                        </td>
                        <td class="text-r">
                            <select id="aarea" name="aarea">
                                <OPTION selected value=0>选择区域</OPTION>
                                <OPTION value=北京>北京</OPTION>
                                <OPTION value=天津>天津</OPTION>
                                <OPTION value=河北>河北</OPTION>
                                <OPTION value=山西>山西</OPTION>
                                <OPTION value=内蒙古>内蒙古</OPTION>
                                <OPTION value=辽宁>辽宁</OPTION>
                                <OPTION value=吉林>吉林</OPTION>
                                <OPTION value=黑龙江>黑龙江</OPTION>
                                <OPTION value=上海>上海</OPTION>
                                <OPTION value=江苏>江苏</OPTION>
                                <OPTION value=浙江>浙江</OPTION>
                                <OPTION value=安徽>安徽</OPTION>
                                <OPTION value=福建>福建</OPTION>
                                <OPTION value=江西>江西</OPTION>
                                <OPTION value=山东>山东</OPTION>
                                <OPTION value=河南>河南</OPTION>
                                <OPTION value=湖北>湖北</OPTION>
                                <OPTION value=湖南>湖南</OPTION>
                                <OPTION value=广东>广东</OPTION>
                                <OPTION value=广西>广西</OPTION>
                                <OPTION value=海南>海南</OPTION>
                                <OPTION value=重庆>重庆</OPTION>
                                <OPTION value=四川>四川</OPTION>
                                <OPTION value=贵州>贵州</OPTION>
                                <OPTION value=云南>云南</OPTION>
                                <OPTION value=西藏>西藏</OPTION>
                                <OPTION value=陕西>陕西</OPTION>
                                <OPTION value=甘肃>甘肃</OPTION>
                                <OPTION value=青海>青海</OPTION>
                                <OPTION value=宁夏>宁夏</OPTION>
                                <OPTION value=新疆>新疆</OPTION>
                                <OPTION value=香港>香港</OPTION>
                                <OPTION value=澳门>澳门</OPTION>
                                <OPTION value=台湾>台湾</OPTION>
                                <OPTION value=国外>国外</OPTION>
                                <OPTION value=微信群>微信群</OPTION>
                            </select>
                        </td>
                        
            		</tr>
        		</table>
             </form> 
            
        	<div id="content">
             <?php
				require_once("../connectMysql/connetMysql.class.php");
				$pro_status = array(1=>'有个好想法',2=>'寻找小伙伴',3=>'产品研发中',4=>'产品运营中'); 
				$pro_type = array(1=>'社交',2=>'工具',3=>'游戏',4=>'教育',5=>'媒体',6=>'旅游',7=>'金融',8=>'硬件',9=>'体育',10=>'O2O',11=>'新农业',12=>'电子商务',13=>'移动应用',14=>'企业服务',15=>'文化艺术',16=>'营销广告',17=>'视频娱乐',18=>'健康医疗',19=>'搜索安全',20=>'创业服务',21=>'站长工具',22=>'企业服务',23=>'酒店服务',24=>'其他应用'); 
				$db=new connetMysql;
				$con=$db->getConnect();
				$chk_sql="SELECT project.ProjectId,project.ProName,project.ProProv,project.ProCity,project.ProDescri,project.ProType,project.ProStatus,user.UserName,user.PetName FROM project,user WHERE ProStart>now() AND project.Userid=user.UserId ORDER BY project.ProjectId";	
				$result=$con->query($chk_sql);
				while ($row = mysqli_fetch_assoc($result))
				{
            ?>
              <a href="proshow.php?projectid=<?php echo $row['ProjectId'];?>">
               <div class="mainIconPane">
               		<div class="u-icon">
                        <span  class="u-img"><br /><span class="u-text"><?php echo mb_substr($row['ProName'], 0, 1, 'utf-8'); ?></span></span>
                        
                    </div>
                    <div class="u-all">
                        <div class="u-info">
                       		<span class="userName"><?php echo $row['ProName'];?></span>
                   		 	<span class="tag">&nbsp;<?php echo $pro_status[$row['ProStatus']];?>&nbsp;</span>
                            <div class="u-decri">
                               <p>
                                <span class="c-green-1">
								<?php 
									if(empty($row['PetName']))
                                   		echo $row['UserName']."/".$row['ProProv']."/".$row['ProCity']."/".$pro_type[$row['ProType']];
									else
										echo $row['PetName']."/".$row['ProProv']."/".$row['ProCity']."/".$pro_type[$row['ProType']];
                                ?></span> 
                        	   </p>
                               <p>
                                <span class="c-green">
								<?php 
                                    echo $row['ProDescri'];
                                        ?></span> 
                        	   </p>
                            </div>
                          </div>
                     </div>
				</div>  
			</a>
                <?php }
					$db->clossConnet();
				 ?>          
             </div>
             <div id="nodata"></div> 
        </div>
		
		<div class="foot">
    		<!-- Footer -->
            <section class="footer">
                <ul>
                    <li><a href="../people/person.php"><img src="../img/icons/blog.png" width="18" height="26" alt="icon"><span>人</span></a></li>
                    <li><a href="../index.php"><img src="../img/icons/contact.png" width="27" height="26" alt="icon"/><span>约</span></a></li>                   
                   	<li><a href="../me/me.php"><img src="../img/icons/about.png" width="25" height="26" alt="icon"/><span>我</span></a></li>           
                </ul>
            </section>

			<!--End Footer -->
    	</div>

</body>

</html>